﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections.ObjectModel;
using cecbData;
using ExcelLibrary;
using ExcelLibrary.SpreadSheet;
using System.IO;


namespace Dss.Methods
{
    public class ProjectQuestions
    {
        public ProjectQuestions()
        {

            cecbContext = new DSSEntities();
        }

        DSSEntities cecbContext;



        //public void WriteToAnExcel()
        //{

        //    string file = "D:\\CECB.xls";
        //    Workbook workbook = new Workbook();
        //    Worksheet worksheet = new Worksheet("First Sheet");
        //    int z = 0;
        //    //for (int z = 0; z < getAllActivityDetails().Count; z++)
        //    foreach (Activities act in getAllActivityDetails())
        //    {
        //        z++;
        //        worksheet.Cells[z, 0] = new Cell(act.actv_name);
        //        worksheet.Cells[1, z] = new Cell(act.actv_reference);

        //    }

        //    worksheet.Cells.ColumnWidth[0, 1] = 3000;
        //    worksheet.Name = "sss";

        //    workbook.Worksheets.Add(worksheet);
        //    workbook.Save(file);
        //    //==================================================

        //    //  FileInfo newFile = new FileInfo(@"D:\sample6.xlsx");

        //    //    ExcelPackage pck = new ExcelPackage(newFile);
        //    //Add the Content sheet
        //    //  var ws = Workbook.Worksheets.Add("Content");
        //    //  ws.View.ShowGridLines = false;



        //}

    }
}


// worksheet.Cells[0, 1] = new Cell((short)1);
// worksheet.Cells[2, 0] = new Cell(9999999);
//worksheet.Cells[3, 3] = new Cell((decimal)3.45);
//worksheet.Cells[2, 2] = new Cell("Text string");
//worksheet.Cells[2, 4] = new Cell("Second string");
//worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00");
//worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD");